package cn.learn.office.excel_v2;

import cn.learn.office.excel_v2.sort.ArrayList4TableSort;

import java.io.File;

/**
 * 测试excel表格
 *
 * @author huangyezhan
 * @version 2.0
 * @date 2020年04月20日16:54
 */
@Deprecated
public class ExcelTestDemo {

    private final static String multipleHeader = "[" +
            "[{tileName:'表1-1',rowspan:2,colspan:1},{tileName:'表1-2',rowspan:1,colspan:2},{tileName:'表1-3',rowspan:1,colspan:0}]" +
            "[{tileName:'表1-1',rowspan:0,colspan:1},{tileName:'表2-1',rowspan:2,colspan:1},{tileName:'表2-2',rowspan:1,colspan:1}]" +
            "[{tileName:'表3-1',rowspan:1,colspan:1},{tileName:'表3-2',rowspan:0,colspan:1},{tileName:'表3-3',rowspan:1,colspan:1}]" +
            "]";


    public static void main(String[] args) {
        ExportExcelVo vo = new ExportExcelVo();
        vo.setExcelName("测试表头");
        vo.setMultipleHeader(multipleHeader);
        vo.setHandlerSort(ArrayList4TableSort.class);

        File file = new File("E:/测试模型.xlsx");
        GenerateExcelUtil.generateExcel(vo, file);
    }

}
